Python Job: Data Solutions Analyst

Flexiti is one of Canada’s fastest growing fintech lenders. We aim to make our customers’ lives more affordable and help our retail partners grow their sales by offering flexible financing options. Through our award-winning omni-channel platform, customers can be approved instantly to shop with their FlexitiCard®, which they can use online or in-store to make multiple purchases, within their credit limit, without needing to reapply.

At Flexiti, we work hard, we love what we do, and we have some fun along the way! If you are looking for an energizing and innovative work environment with great people and big ideas, we’d love to have you join us!

To learn more about Flexiti, please visit www.flexiti.com

Data Solutions Analyst

Flexiti is looking for a resourceful person who will be responsible for end-to-end database design, development, testing, review, and implementation of code into existing databases for all levels of the Software Development Lifecycle.

What you will be doing:

• Analyze business, IT and data requirements, document data solutions and ETL processes, and support implementation of data solutions (OLTP & OLAP) accordingly.
• Collaborate with Product Owners, PMs, Scrum masters and participate in projects to support data engineering requirements, design and testing
• Partner with analytics and business teams to improve data models that feed business intelligence tools
• Perform analyses on existing data models, pipeline, processes, etc., and document findings and provide recommendations and action plans to update or improve them for corporate projects and improvement initiatives
• Develop Advanced T-SQL such as temporal tables, PIVOTs, recursive table expressions, dynamic SQL as well as high complexity, fast performing SELECT queries, T-SQL procedures, functions, triggers, views, jobs, scripts to support data operations and DW users.
• Optimize SQL statements executed by end users/ETL code as required; Test and troubleshoot ETL job functionality, validate database objects and structures through use of SQL and other means
• Drive optimization, testing and tooling to improve data quality; Test and troubleshoot ETL job functionality, validate database objects and structures through use of SQL and other means
• Work closely with QA Test Engineers to develop and execute test cases and ensure appropriate test coverage

What you should have:

• 3 years of experience in Databases with a least one year of business or systems analysis
• Knowledge of MSSQL, MongoDB, SOAP/XML, REST/JSON
• Understanding of ELT and ETL and hands on experience with SSIS, SSRS (development and some admin experience)
• Experience with data modeling (OLTP and OLAP) using Erwin, Visio or similar tools
• Experience in all aspects of SDLC
• Working knowledge of AWS Cloud (RDS)
• Spark, R and python experience are an asset
• Familiarity with ad-hoc file transfer solution/s, such as FTP, HTTP
• Experience with modeling Power BI data modeling, designing dashboards is desirable
• Financial services experience is an asset

Why you would love to work here:

• You’ll be a part of an award-winning, fast-growing company
• Our innovative culture promotes on-going learning opportunities with training and mentorship
• Competitive compensation package commensurate to experience plus benefits
  
• A work from anywhere mentality!

Flexiti embraces diversity. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills. All qualified applicants will receive consideration without regard to race, ancestry, place of origin, colour, ethnic origin, citizenship, creed, sex, sexual orientation, disability, age, marital status, or family status. If you require disability-related accommodation during the application or interview process, simply let us know and we’ll work with you to ensure you have a positive experience.